<?xml version="1.0" encoding="UTF-8"?>
<k3IntegrationFormData>
	<form key="integrationExpenseReimburse">
		<description>费用报销</description>
		<!-- 跳转页面 -->
		<page>
			/modules/workflow/integrationExpenseReimburse.jsp
		</page>

		<!--
			查询sql,从表WORKFLOW_FILE中获取数据的sql,获取 短字段和长字段类型是从此表取数据
			,注意在多表关联时，WORKFLOW_FILE使用别名w
		-->
		<sqlListFromFiles>
			<sqlFromFile>
				SELECT W.* FROM
				WORKFLOW_FILE W WHERE W.FLOWTYPE_ID = 140  and W.ID = ?
			</sqlFromFile>
			<sqlFromFile>
				SELECT U.ID AS USERID, U.USERNAME
				FROM SYSTEM_USERS U,
				WORKFLOW_FILE W
				WHERE U.ID = W.USER_ID AND W.FLOWTYPE_ID = 140  and W.ID = ?
			</sqlFromFile>
		</sqlListFromFiles>


		<!--  查询表单的明细数据类型的 字段，从WORKFLOW_FILEDETAIL中获取的数据 -->
		<sqlListFormFileDetails>
			<sqlFormFileDetail>
			</sqlFormFileDetail>
		</sqlListFormFileDetails>

		<!-- 查询表单中的列表类型的数据字段，从 WORKFLOW_FILELIST中获取的数据 -->
		<sqlListFormFileLists>
			<sqlFormFileList>
				SELECT W.FIELDSTR1 AS LISTFIELDSTR1, W.FIELDSTR2 AS
				LISTFIELDSTR2,
				W.FIELDSTR3 AS LISTFIELDSTR3 FROM WORKFLOW_FILELIST W
				WHERE
				W.FIELDSTR1 IS NOT NULL AND W.FIELDSTR2 IS NOT NULL  and W.FILE_ID = ?
			</sqlFormFileList>
		</sqlListFormFileLists>
		<!--
			在表单中存在一些数据是来自异构系统的，保存的表单时保存的是名字，在保存异构系统的
			时候需要保存对应的ID，下面的配置将从异构系统中依据名字获取相应的Id号
			key代表从
		-->
		<idsFromName>
			<sql key="FIELDSTR1" targetKey="applyerID" des="报销人">
				select e.FItemID from t_emp e
				where e.FName='?'
			</sql>
			<sql key="FIELDSTR2" targetKey="applyDepartmentID" des="报销部门">
				select d.FItemID from t_Department d where d.FName='?'
			</sql>

			<sql key="FIELDSTR9" targetKey="currencyID" des="币别">
				select c.FCurrencyID from t_Currency c where c.FName='?'
			</sql>
		</idsFromName>
	</form>
	<form key="integrationFeeApplication">
		<description>费用（借款）申请</description>
		<!-- 跳转页面 -->
		<page>
			/modules/workflow/integrationFeeApplication.jsp
		</page>

		<!--
			查询sql,从表WORKFLOW_FILE中获取数据的sql,获取 短字段和长字段类型是从此表取数据
			,注意在多表关联时，WORKFLOW_FILE使用别名w
		-->
		<sqlListFromFiles>
			<sqlFromFile>
				SELECT W.* FROM WORKFLOW_FILE W WHERE W.FLOWTYPE_ID =280  and W.ID = ?
			</sqlFromFile>
		</sqlListFromFiles>
		<!--
			在表单中存在一些数据是来自异构系统的，保存的表单时保存的是名字，在保存异构系统的
			时候需要保存对应的ID，下面的配置将从异构系统中依据名字获取相应的Id号
			key代表从数据集中获取的key值，targetKey为写入到request中的值
		-->
		<idsFromName>
			<sql key="FIELDSTR3" targetKey="applyerID" des="借款人">
				select e.FItemID from t_emp e
				where e.FName='?'
			</sql>
			<sql key="FIELDSTR4" targetKey="applyDepartmentID" des="借款部门">
				select d.FItemID from t_Department d where d.FName='?'
			</sql>

			<sql key="FIELDSTR5" targetKey="currencyID" des="币别">
				select c.FCurrencyID from t_Currency c where c.FName='?'
			</sql>
			<sql key="FIELDSTR11" targetKey="settleTypeID" des="支付方式">
				select s.FItemID from t_Settle s where s.FName='?'
			</sql>
		</idsFromName>
	</form>

	
	<form key="integrationmyApplication">
		<description>费用（借款）申请</description>
		<!-- 跳转页面 -->
		<page>
			/modules/workflow/integrationFeeApplication.jsp
		</page>

		<!--
			查询sql,从表WORKFLOW_FILE中获取数据的sql,获取 短字段和长字段类型是从此表取数据
			,注意在多表关联时，WORKFLOW_FILE使用别名w
		-->
		<sqlListFromFiles>
			<sqlFromFile>
				SELECT W.* FROM WORKFLOW_FILE W WHERE W.FLOWTYPE_ID =280  and W.ID = ?
			</sqlFromFile>
		</sqlListFromFiles>
		<!--
			在表单中存在一些数据是来自异构系统的，保存的表单时保存的是名字，在保存异构系统的

			时候需要保存对应的ID，下面的配置将从异构系统中依据名字获取相应的Id号

			key代表从数据集中获取的key值，targetKey为写入到request中的值

		-->
		<idsFromName>
			<sql key="FIELDSTR3" targetKey="applyerID" des="借款人">
				select e.FItemID from t_emp e
				where e.FName='?'
			</sql>
			<sql key="FIELDSTR4" targetKey="applyDepartmentID" des="借款部门">
				select d.FItemID from t_Department d where d.FName='?'
			</sql>

			<sql key="FIELDSTR5" targetKey="currencyID" des="币别">
				select c.FCurrencyID from t_Currency c where c.FName='?'
			</sql>
			<sql key="FIELDSTR11" targetKey="settleTypeID" des="支付方式">
				select s.FItemID from t_Settle s where s.FName='?'
			</sql>
		</idsFromName>
	</form>
	
</k3IntegrationFormData>